<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="group_04.User" %>

<%--
  Created by IntelliJ IDEA.
  User: LENOVO
  Date: 2018/5/26
  Time: 20:50
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>用户信息列表</title>
    <style type="text/css">
        table{
            border-collapse: collapse;
        }
        td{
            border: 1px solid #000;
            padding: 10px;
        }
    </style>
</head>
<body style="background-image: url(image/500500291.jpg); background-size: 100%;">
<button type="button" name="userAdd">
    <a href="userAdd.jsp">添加用户</a>
</button>
<button type="button" name="logout">
    <a href="logout.jsp">注销登录</a>
</button><br/>

<div style="text-align:center;margin-top:50px">
    <h1>用户列表</h1>
        <table align="center">
    <tr align="center" valign="middle">
        <td>编号 </td>
        <td>姓名 </td>
        <td>密码 </td>
        <td>操作1</td>
    </tr>

    <%
        //数据库中读取数据保存在List集合中
        List<User> userList=new ArrayList<User>();

        //3+1读取数据库数据保存到List中
        Connection connection=null;
        Statement statement=null;
        ResultSet resultSet=null;

        String sql="select * from g_users";

        Class.forName("com.mysql.jdbc.Driver");


        connection= DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
                "root",
                "123456"
        );

        statement=connection.createStatement();
        resultSet=statement.executeQuery(sql);

        while(resultSet.next()){
            int id=resultSet.getInt(1);
            String name=resultSet.getString(2);
            String password=resultSet.getString(3);

            User user = new User();

            user.setId(id);
            user.setName(name);
            user.setPassword(password);

            userList.add(user);
        }


        resultSet.close();
        statement.close();
        connection.close();

        request.setAttribute("userList", userList);

    %>



    <%--易错点 ${userList}不能少${}--%>
    <c:forEach var="user" items="${userList}">
     <tr>
         <td>${user.id}</td>
         <td>${user.name}</td>
         <td>${user.password}</td>
         <td>
             <a href="userDelete.jsp?id=${user.id}">删除</a>
         </td>
     </tr>
    </c:forEach>

</table>
</div>
</body>
</html>
